(0, 1) THIS IS THE MACRO THAT UPDATES STOCK PRICES
(0, 2) CLOSE_ALL_DOCUMENTS
(0, 3)
(0, 4) MPM_1.61_HELP!1
(0, 5) 150
(0, 6) 15
(0, 7) 425
(0, 8) 285
(0, 12) MPM
(1, 0) FALSE
(1, 1) TURNS OFF SCREEN ECHO
(1, 2) FALSE
(1, 3)
(1, 4) 17
(1, 5) 10
(1, 6) 10
(1, 9) 2
(1, 12) Update Prices…
(1, 13) UPDATE_PRICES
(1, 15) Enter current prices for any portfolio.
(1, 16) MPM_1.61_HELP!14
(2, 0) TRUE
(2, 2) #N/A!
(2, 3)
(2, 4) 5
(2, 5) 55
(2, 6) 20
(2, 9) Enter data below...
(2, 12) Edit a Portfolio…
(2, 13) EDIT_A_PORTFOLIO
(2, 15) Add, delete, or modify an item in any portfolio…
(2, 16) MPM_1.61_HELP!15
(3, 0) 6
(3, 2) TRUE
(3, 3)
(3, 4) 5
(3, 5) 10
(3, 6) 60
(3, 9)
(3, 12) Make a Brand New Portfolio…
(3, 13) MAKE_NEW_PORTFOLIO
(3, 15) Add the first item to a brand new portfolio.
(3, 16) MPM_1.61_HELP!16
(4, 0) FALSE
(4, 2) TRUE
(4, 3)
(4, 4) 5
(4, 5) 10
(4, 6) 80
(4, 9)
(4, 12) Special Functions…
(4, 13) SPECIAL_FUNCTIONS
(4, 15) Make reports, change screen echo, remove menu, etc.
(4, 16) MPM_1.61_HELP!17
(5, 0) FALSE
(5, 2) FALSE
(5, 3)
(5, 4) 5
(5, 5) 10
(5, 6) 100
(5, 9)
(5, 12) -
(5, 13)
(5, 14)
(5, 15)
(5, 16)
(6, 0) #N/A!
(6, 2) TRUE
(6, 3)
(6, 4) 5
(6, 5) 10
(6, 6) 120
(6, 9)
(6, 12) Open One Item…
(6, 13) OPEN_A_SINGLE_ITEM
(6, 15) Open one specific item only.
(6, 16) MPM_1.61_HELP!18
(7, 0) TRUE
(7, 2) #N/A!
(7, 3)
(7, 4) 5
(7, 5) 200
(7, 6) 60
(7, 9)
(7, 12) Open All Items in One Portfolio…
(7, 13) OPEN_ITEMS
(7, 15) Open all files related to any portfolio.
(7, 16) MPM_1.61_HELP!19
(8, 0) TRUE
(8, 2) FALSE
(8, 3)
(8, 4) 5
(8, 5) 200
(8, 6) 80
(8, 9)
(8, 12) Open One Portfolio…
(8, 13) OPEN_SINGLE_PORTFOLIO
(8, 14)
(8, 15) Open one specific portfolio only.
(8, 16) MPM_1.61_HELP!20
(9, 0) FALSE
(9, 2) FALSE
(9, 3)
(9, 4) 5
(9, 5) 200
(9, 6) 100
(9, 9)
(9, 12) Close Items - One Portfolio Only…
(9, 13) CLOSE_PORTFOLIO_ITEMS
(9, 15) Close linked files to a single portfolio.
(9, 16) MPM_1.61_HELP!21
(10, 0) FALSE
(10, 2) FALSE
(10, 3)
(10, 4) 5
(10, 5) 200
(10, 6) 120
(10, 9)
(10, 12) Close All Items Only
(10, 13) CLOSE_ITEMS
(10, 15) Close all files linked to all portfolios.
(10, 16) MPM_1.61_HELP!22
(11, 0) TRUE
(11, 2) FALSE
(11, 3)
(11, 4) 5
(11, 5) 10
(11, 6) 190
(11, 9)
(11, 12) -
(12, 0) TRUE
(12, 2) FALSE
(12, 3)
(12, 4) 5
(12, 5) 10
(12, 6) 220
(12, 9)
(12, 12) Help…
(12, 13) MPM_HELP
(12, 15) Help for this program only (NOT MS Excel help).
(12, 16) MPM_1.61_HELP!23
(13, 0) TRUE
(13, 4) 5
(13, 5) 10
(13, 6) 250
(13, 9) P/E, 1 Yr. Ret.: 22.00%
(13, 12) Add a New Help Topic…
(13, 13) MAKE_NEW_HELP
(13, 15) Modify MPM help (NOT MS Excel help).
(13, 16) MPM_1.61_HELP!24
(14, 0) TRUE
(14, 2) OPEN_ITEMS
(14, 4) 5
(14, 5) 10
(14, 6) 160
(14, 9) New Price:
(14, 12) Remove a Help Topic…
(14, 13) REMOVE_HELP
(14, 15) Remove a topic from MPM help (NOT MS Excel help).
(14, 16) MPM_1.61_HELP!25
(15, 0) FALSE
(15, 2) FALSE
(15, 4) 8
(15, 5) 185
(15, 6) 157
(15, 7) 110
(15, 12) Tutorial…
(15, 13) TUTORIAL
(15, 15) Rehearse some common commands on a sample portfolio…
(15, 16) MPM_1.61_HELP!26
(16, 0) 4
(16, 2) FALSE
(16, 4) 8
(16, 5) 185
(16, 6) 187
(16, 7) 110
(16, 12) About This Program…
(16, 13) ABOUT
(17, 0) FALSE
(17, 2) #N/A!
(17, 4) 8
(17, 5) 185
(17, 6) 217
(17, 7) 110
(17, 12) -
(18, 0) TRUE
(18, 1) M4 IS THE UPPER LEFT CORNER OF THE TABLE
(18, 2) TRUE
(18, 4) 6
(18, 5) 185
(18, 6) 247
(18, 7) 110
(18, 12) Quit My Portfolio Manager
(18, 13) CLOSE_ALL_DOCUMENTS
(18, 15) Removes all documents and this menu.
(18, 16) MPM_1.61_HELP!27
(19, 0) TRUE
(19, 1) IF THERE IS NO ISSUE, THEN YOU ARE DONE. SHOW THE PORTFOLIO SUMMARY
(19, 2) TRUE
(19, 4) 1
(19, 5) 320
(19, 6) 220
(19, 7) 64
(19, 9) OK
(19, 12)
(20, 0) TRUE
(20, 1) LOAD STOCK INFORMATION INTO THE DIALOG BOX
(20, 2) FALSE
(20, 4) 2
(20, 5) 320
(20, 6) 250
(20, 7) 64
(20, 9) Cancel
(20, 13) SAMPLE PORTFOLIO
(21, 0) TRUE
(21, 2) FALSE
(21, 12) What to do if any cells show #REF!…
(22, 0) TRUE
(22, 2) TRUE
(22, 12) What to do if you get a “Can’t find…” error…
(23, 0) TRUE
(23, 2) TRUE
(23, 4) MPM_1.61_HELP!2
(23, 5) 161
(23, 6) 105
(23, 7) 390
(23, 8) 159
(23, 12) What if your portfolio does not update…
(24, 0) TRUE
(24, 2) TRUE
(24, 3) OPEN ALL THE FILES THAT ARE LINKED TO STOCKS
(24, 4) 5
(24, 5) 7
(24, 6) 5
(24, 9) Portfolio Summary:
(24, 12) What if your portfolio cannot be found…
(25, 0) TRUE
(25, 2) TRUE
(25, 3) MAKE IT THE ACTIVE WINDOW, NOT THE LAST ITEM YOU JUST OPENED
(25, 4) 5
(25, 5) 7
(25, 6) 30
(25, 9) Date:
(25, 12) What if you duplicate information by mistake…
(26, 0) TRUE
(26, 2) TRUE
(26, 4) 5
(26, 5) 50
(26, 6) 30
(26, 9)
(26, 12) What if you cannot make a portfolio…
(27, 0) TRUE
(27, 2) TRUE
(27, 3) REMOVES THE MESSAGE
(27, 4) 5
(27, 5) 7
(27, 6) 55
(27, 9) Total Items in Portfolio:
(27, 12) What to do if a item file gets corrupted or is unusable…
(28, 0) TRUE
(28, 2) TRUE
(28, 4) 5
(28, 5) 7
(28, 6) 80
(28, 9) Base Price:
(28, 12) What if you are unable to delete a directory in an old portfolio…
(29, 0) TRUE
(29, 4) 5
(29, 5) 7
(29, 6) 105
(29, 9) Total Gain or Loss:
(29, 12) What if annual return figures seem illogical…
(30, 0) TRUE
(30, 4) 5
(30, 5) 7
(30, 6) 130
(30, 9) Portfolio Value:
(30, 12) What to do if a portfolio will not open…
(31, 0) TRUE
(31, 2) REMOVE_MENU
(31, 4) 5
(31, 5) 275
(31, 6) 55
(31, 9)
(31, 12) How to update portfolios at the end of a year…
(32, 0) TRUE
(32, 2) TRUE
(32, 4) 5
(32, 5) 275
(32, 6) 80
(32, 9)
(33, 0) TRUE
(33, 1) ERASE THE CELL FOR THE UPDATED PRICE
(33, 2) TRUE
(33, 3) DELETE THE MPM MENU FROM THE MENU BAR
(33, 4) 5
(33, 5) 275
(33, 6) 105
(33, 9)
(34, 0) 19
(34, 1) ASK FOR THE NEW PRICE
(34, 2) TRUE
(34, 4) 5
(34, 5) 275
(34, 6) 130
(34, 9)
(35, 0) FALSE
(35, 1) IF THE USER HITS CANCEL THEN GO TO THE PORTFOLIO SUMMARY
(35, 2) TRUE
(35, 4) 1
(35, 5) 280
(35, 6) 10
(35, 7) 64
(35, 9) OK
(36, 0) FALSE
(36, 2) TRUE
(37, 0) TRUE
(37, 1) CHECK TO SEE IF THE PRICE IS GREATER THAN ZERO
(38, 0) TRUE
(38, 4) MPM_1.61_HELP!3
(38, 5) 150
(38, 6) 30
(38, 7) 385
(38, 8) 375
(38, 9) New Purchase
(39, 0) TRUE
(39, 1) THIS STATEMENT CHECKS TO SEE IF THE NEW PRICE IS WITHIN 20% OF THE OLD PRICE
(39, 2) TRANSACTION_ON_EXISTING_PORTFOLIO
(39, 3) THIS MACRO IS FOR ADDING TO AN EXISTING STOCK
(39, 4) 5
(39, 5) 10
(39, 6) 5
(39, 9) Please fill in all of the items below:
(40, 0) FALSE
(40, 2) TRUE
(40, 4) 5
(40, 5) 10
(40, 6) 28
(40, 9) Name:
(41, 0) TRUE
(41, 1) THE 52-WEEK HIGH MUST BE HIGHER THAN THE 52-WEEK LOW
(41, 2) TRUE
(41, 4) 6
(41, 5) 75
(41, 6) 25
(41, 7) 240
(42, 0) TRUE
(42, 2) TRUE
(42, 4) 5
(42, 5) 10
(42, 6) 59
(42, 9) Symbol:
(43, 0) TRUE
(43, 2) TRUE
(43, 4) 6
(43, 5) 75
(43, 6) 55
(43, 7) 100
(44, 0) TRUE
(44, 2) TRUE
(44, 3) MAKES THE RANGE BLANK
(44, 4) 5
(44, 5) 10
(44, 6) 90
(44, 9) Exchange:
(45, 0) TRUE
(45, 1) THE PRICE MUST BE BETWEEN THE NEW HIGH AND THE NEW LOW.
(45, 2) 31
(45, 3) LETS YOU PUT IN THE INFORMATION WHEN YOU ADD TO AN EXISTING STOCK
(45, 4) 11
(45, 5) 0
(45, 6) 0
(46, 0) FALSE
(46, 2) FALSE
(46, 3) IF YOU HIT CANCEL THEN EVERYTHING STOPS
(46, 4) 12
(46, 5) 100
(46, 6) 90
(46, 9) NYSE
(47, 0) TRUE
(47, 1) PUT THE PRICE THAT WAS ENTERED INTO STOCKS
(47, 2) TRUE
(47, 3) IF THE DATE YOU PUT IN IS LESS THAN NOW THEN GO TO THE NEXT TEST
(47, 4) 12
(47, 5) 160
(47, 6) 90
(47, 9) AMEX
(48, 0) FALSE
(48, 2) TRUE
(48, 4) 12
(48, 5) 225
(48, 6) 90
(48, 9) OTC
(49, 0) FALSE
(49, 2) TRUE
(49, 4) 12
(49, 5) 275
(49, 6) 90
(49, 9) NONE
(50, 0) FALSE
(50, 2) TRUE
(50, 4) 5
(50, 5) 10
(50, 6) 121
(50, 9) Date purchased:
(51, 0) FALSE
(51, 2) TRUE
(51, 4) 8
(51, 5) 130
(51, 6) 118
(51, 7) 80
(51, 10)
(52, 0) TRUE
(52, 2) TRUE
(52, 4) 5
(52, 5) 10
(52, 6) 152
(52, 9) # of shares:
(53, 0) TRUE
(53, 1) SELECT THE NEXT STOCK
(53, 2) TRUE
(53, 3) CHECKS TO SEE IF THE NUMBER OF SHARES IS GREATER THEN ZERO
(53, 4) 8
(53, 5) 130
(53, 6) 149
(53, 7) 100
(54, 0) TRUE
(54, 2) FALSE
(54, 4) 5
(54, 5) 10
(54, 6) 183
(54, 9) Price per share:
(55, 0) TRUE
(55, 1) PUT THE PORTFOLIO SUMMARY IN THE DIALOG BOX
(55, 2) TRUE
(55, 3) IF THE PRICE IS GREATER THAN ZERO GO TO THE NEXT TEST
(55, 4) 8
(55, 5) 130
(55, 6) 180
(55, 7) 120
(56, 0) TRUE
(56, 2) TRUE
(56, 4) 5
(56, 5) 10
(56, 6) 214
(56, 9) Fees:
(57, 0) TRUE
(57, 2) TRUE
(57, 4) 8
(57, 5) 130
(57, 6) 210
(57, 7) 120
(58, 0) TRUE
(58, 2) TRUE
(58, 4) 5
(58, 5) 10
(58, 6) 245
(58, 9) 52-Week High:
(59, 0) TRUE
(59, 1) GOTO THE STOCK.SYMBOL AND THEN GO OFFSET 0 ROWS, 1 COLUMN TO THE LEFT THEN SUBTRACT ONE FROM THE NUMBER THATS IN THERE
(59, 2) TRUE
(59, 3) MAKE SURE THAT THE FEES ARE GREATER THEN OR EQUAL TO ZERO
(59, 4) 8
(59, 5) 130
(59, 6) 242
(59, 7) 120
(60, 0) TRUE
(60, 2) FALSE
(60, 4) 5
(60, 5) 10
(60, 6) 276
(60, 9) 52-Week Low:
(61, 0) TRUE
(61, 2) TRUE
(61, 4) 8
(61, 5) 130
(61, 6) 272
(61, 7) 120
(62, 0) TRUE
(62, 2) FALSE
(62, 4) 11
(62, 5) 0
(62, 6) 0
(63, 0) 12
(63, 2) TRUE
(63, 4) 12
(63, 5) 10
(63, 6) 297
(63, 9) P/E:
(64, 0) TRUE
(64, 2) TRUE
(64, 4) 12
(64, 5) 10
(64, 6) 314
(64, 9) 1 Yr. Return:
(65, 0) TRUE
(65, 2) TRUE
(65, 4) 6
(65, 5) 130
(65, 6) 304
(65, 7) 74
(66, 0) TRUE
(66, 2) TRUE
(66, 4) 13
(66, 5) 10
(66, 6) 336
(66, 9) Has a div. reinvest program (DRIP)
(67, 2) FALSE
(67, 4) 1
(67, 5) 285
(67, 6) 265
(67, 7) 64
(67, 9) OK
(68, 2) FALSE
(68, 4) 2
(68, 5) 285
(68, 6) 300
(68, 7) 64
(68, 9) Cancel
(69, 0) ADD_TO_PORTFOLIO
(69, 2) FALSE
(69, 4)
(69, 5)
(69, 6)
(69, 7)
(69, 8)
(69, 9)
(69, 10)
(70, 0) TRUE
(70, 2) FALSE
(70, 4)
(70, 5)
(70, 6)
(70, 7)
(70, 8)
(70, 9)
(70, 10)
(71, 0) TRUE
(71, 2) TRUE
(71, 3) PUT INFORMATION INTO A DIALOG BOX
(71, 4) MPM_1.61_HELP!4
(71, 5) 50
(71, 6) 5
(71, 7) 575
(71, 8) 350
(72, 0) FALSE
(72, 2) TRUE
(72, 4) 5
(72, 5) 15
(72, 6) 15
(72, 9)
(73, 0) FALSE
(73, 2) TRUE
(73, 4) 5
(73, 5) 15
(73, 6) 35
(73, 9)
(74, 0) TRUE
(74, 2) TRUE
(74, 4) 5
(74, 5) 15
(74, 6) 75
(74, 9) Date:
(75, 0) TRUE
(75, 2) TRUE
(75, 4) 8
(75, 5) 165
(75, 6) 72
(75, 7) 110
(75, 10)
(76, 0) TRUE
(76, 2) TRUE
(76, 4) 5
(76, 5) 15
(76, 6) 102
(76, 9) Number of shares:
(77, 0) TRUE
(77, 2) TRUE
(77, 4) 5
(77, 5) 15
(77, 6) 119
(77, 9) (Zero if div. payout)
(78, 0) TRUE
(78, 2) TRUE
(78, 4) 8
(78, 5) 165
(78, 6) 105
(78, 7) 110
(79, 0) 29
(79, 1) THIS ASKS THE USER FOR INFORMATION ABOUT THE NEW PURCHASE
(79, 2) 15
(79, 3) THIS DIALOG BOX REPEATS THE INFORMATION THAT YOU JUST PUT IN
(79, 4) 5
(79, 5) 15
(79, 6) 152
(79, 9) Price (If div. payout,
(80, 0) FALSE
(80, 1) IF YOU HIT THE CANCEL BUTTON THEN STOP
(80, 2) FALSE
(80, 3) IF YOU DID HIT CANCEL THEN START OVER
(80, 4) 5
(80, 5) 15
(80, 6) 169
(80, 9) enter amount here):
(81, 0) #N/A!
(81, 2) TRUE
(81, 3) TURN OFF THE ERROR CHECKING
(81, 4) 8
(81, 5) 165
(81, 6) 155
(81, 7) 110
(82, 0) TRUE
(82, 1) THIS MAKES SURE THAT THE USER ENTERED A NAME
(82, 2) #VALUE!
(82, 3) LOOK UP THE SYMBOL OF THE STOCK AND THEN OPEN IT. IF IT IS AN ITEM IT IS A MISTAKE, BUT KEEP GOING ANYWAY
(82, 4) 5
(82, 5) 15
(82, 6) 195
(82, 9) Fees:
(83, 0) FALSE
(83, 2) TRUE
(83, 3) LOOK UP THE SYMBOL AND A /DRIP AND OPEN IT. IF THE FILE DOES NOT EXIST THEN IGNORE IT
(83, 4) 8
(83, 5) 165
(83, 6) 192
(83, 7) 110
(84, 0) TRUE
(84, 2) FALSE
(84, 3) MAKE SURE THAT AN ITEM WAS OPENED, OTHERWISE STOP
(84, 4) 5
(84, 5) 15
(84, 6) 232
(84, 9) 52-Week High:
(85, 0) TRUE
(85, 1) MAKE SURE THAT THE USER ENTERED A SYMBOL
(85, 2) TRUE
(85, 3) PUT ERROR CHECKING BACK ON
(85, 4) 8
(85, 5) 165
(85, 6) 229
(85, 7) 110
(86, 0) TRUE
(86, 2) TRUE
(86, 3) GO TO A1 ON THE ACTIVE WORK SHEET
(86, 4) 5
(86, 5) 15
(86, 6) 269
(86, 9) 52-Week Low:
(87, 0) TRUE
(87, 2) FALSE
(87, 4) 8
(87, 5) 165
(87, 6) 266
(87, 7) 110
(88, 0) TRUE
(88, 2) TRUE
(88, 3) GO DOWN TO THE LAST ENTRY
(88, 4) 5
(88, 5) 15
(88, 6) 306
(88, 9) P/E - 1 Yr. Ret.:
(89, 0) FALSE
(89, 2) TRUE
(89, 3) TAKES YOU DOWN ONE ROW
(89, 4) 8
(89, 5) 165
(89, 6) 303
(89, 7) 110
(90, 0) FALSE
(90, 2) TRUE
(90, 3) WRITE THE DATE IN THE ITEM
(90, 4) 5
(90, 5) 290
(90, 6) 75
(90, 9) Type of transaction:
(91, 0) FALSE
(91, 2) TRUE
(91, 4) 11
(91, 5) 0
(91, 6) 0
(92, 0) TRUE
(92, 1) MAKE SURE THAT YOU PUT IN A DATE THAT IS NOT IN THE FUTURE
(92, 2) TRUE
(92, 4) 12
(92, 5) 300
(92, 6) 96
(92, 9) Purchase or sale
(93, 0) FALSE
(93, 2) TRUE
(93, 3) WRITE BUY, DIVIDEND, OCP IN COLUMN B
(93, 4) 12
(93, 5) 300
(93, 6) 117
(93, 9) Dividend reinvest
(94, 0) TRUE
(94, 2) TRUE
(94, 3) WRITE THE NUMBER OF SHARES IN COLUMN C
(94, 4) 12
(94, 5) 300
(94, 6) 138
(94, 9) Dividend payout
(95, 0) TRUE
(95, 2) TRUE
(95, 3) WRITE THE PRICE IN COLUMN D
(95, 4) 12
(95, 5) 300
(95, 6) 159
(95, 9) Optional cash payment
(96, 0) TRUE
(96, 1) MAKE SURE THAT THE PRICE IS GREATER THAN ZERO AND THAT THE PRICE IS IN 8THS, 16THS, 32ENDS, 64THS
(96, 2) TRUE
(96, 3) WRITE THE TOTAL FEES IN COLUMN E
(96, 4) 12
(96, 5) 300
(96, 6) 180
(96, 9) Split or reorganization
(97, 0) FALSE
(97, 2) FALSE
(97, 4) 5
(97, 5) 290
(97, 6) 220
(97, 9) Portfolio display options:
(98, 0) TRUE
(98, 2) TRUE
(98, 3) SELECT THE TOTAL SHARES, TOTAL TRANSACTION,TOTAL, TOTAL INVESTMENT
(98, 4) 11
(98, 5) 0
(98, 6) 0
(99, 0) TRUE
(99, 2) TRUE
(99, 3) FILLS DOWN THE THREE FORMULAS
(99, 4) 12
(99, 5) 300
(99, 6) 241
(99, 9) Don’t show this transaction
(100, 0) TRUE
(100, 1) MAKE SURE THAT THE FEES ARE GREATER THAN OR EQUAL TO ZERO
(100, 2) TRUE
(100, 3) SELECTS THE PREVIOUS TRANSACTION
(100, 4) 12
(100, 5) 300
(100, 6) 262
(100, 9) Show this transaction
(101, 0) FALSE
(101, 2) TRUE
(101, 3) IT COPYS WHAT YOU SELECTED
(101, 4) 12
(101, 5) 300
(101, 6) 283
(101, 9) Let this program decide
(102, 0) TRUE
(102, 2) TRUE
(102, 3) GO DOWN ONE ROW
(102, 4) 1
(102, 5) 425
(102, 6) 15
(102, 7) 64
(102, 9) OK
(103, 0) TRUE
(103, 2) TRUE
(103, 3) PASTE FORMATS
(103, 4) 2
(103, 5) 425
(103, 6) 50
(103, 7) 64
(103, 9) Cancel
(104, 0) TRUE
(104, 2) TRUE
(104, 3) SELECT THE NEW TOTAL SHARES COLUMN
(105, 0) FALSE
(105, 2) TRUE
(105, 3) DEFINE THE TOTAL SHARES TO BE THE ACTIVE CELL
(106, 0) FALSE
(106, 2) TRUE
(106, 4) MPM_1.61_HELP!5
(106, 5)
(106, 6)
(106, 7) 425
(106, 8) 210
(107, 0) TRUE
(107, 2) TRUE
(107, 3) DEFINE THE NEW TOTAL INVESTMENT TO BE THE ACTIVE CELL
(107, 4) 17
(107, 5) 9
(107, 6) 9
(107, 9) 2
(108, 0) TRUE
(108, 1) MAKE SURE THAT THE PRICE IS LESS THAN THE 52 WEEK HIGH
(108, 2) TRUE
(108, 4) 5
(108, 5) 53
(108, 6) 10
(108, 9) Is this information correct?
(109, 0) FALSE
(109, 2) TRUE
(109, 3) GOTO THE LAST ENTRY IN COLUMN F (FUNDS)
(109, 4) 5
(109, 5) 16
(109, 6) 65
(109, 9) Transaction date:
(110, 0) TRUE
(110, 2) TRUE
(110, 4) 5
(110, 5) 200
(110, 6) 65
(110, 9)
(111, 0) TRUE
(111, 2) TRUE
(111, 3) GOTO THE LAST ENTRY IN COLUMN B (CODES)
(111, 4) 5
(111, 5) 16
(111, 6) 88
(111, 9) Name:
(112, 0) TRUE
(112, 1) MAKE SURE THAT THE 52 WEEK LOW IS GREATER THAN ZERO AND THAT THE 52 WEEK LOW IS IN 8THS, 16THS, 32NDS, 64THS
(112, 2) TRUE
(112, 4) 5
(112, 5) 200
(112, 6) 88
(112, 9)
(113, 0) FALSE
(113, 2) TRUE
(113, 3) SELECT ALL OF THE NEW “CODES”
(113, 4) 5
(113, 5) 16
(113, 6) 111
(113, 9) Number of shares:
(114, 0) FALSE
(114, 2) TRUE
(114, 4) 5
(114, 5) 200
(114, 6) 111
(114, 9)
(115, 0) FALSE
(115, 2) TRUE
(115, 3) GOTO THE LAST ENTRY IN COLUMN A (DATES)
(115, 4) 5
(115, 5) 16
(115, 6) 134
(115, 9) Price per share:
(116, 0) TRUE
(116, 1) MAKE SURE THAT THE PRICE IS GREATER THAN THE 52 WEEK LOW
(116, 2) TRUE
(116, 4) 5
(116, 5) 200
(116, 6) 134
(116, 9)
(117, 0) FALSE
(117, 2) TRUE
(117, 3) SELECT ALL OF THE NEW “DATES”
(117, 4) 5
(117, 5) 16
(117, 6) 157
(117, 9) Total fees:
(118, 0) TRUE
(118, 2) TRUE
(118, 4) 5
(118, 5) 200
(118, 6) 157
(118, 9)
(119, 0) TRUE
(119, 2) TRUE
(119, 4) 5
(119, 5) 16
(119, 6) 180
(119, 9) Type of transaction:
(120, 0) TRUE
(120, 1) MAKE SURE THAT THE HIGH IS GREATER THAN THE LOW
(120, 2) TRUE
(120, 3) ACTIVATE STOCKS IN CASE IT IS NOT THE ACTIVE WINDOW
(120, 4) 5
(120, 5) 200
(120, 6) 180
(120, 9)
(121, 0) TRUE
(121, 2) TRUE
(121, 3) WRITE THE PRICE THAT WAS JUST ENTERED INTO THE TABLE IN STOCKS
(121, 4) 1
(121, 5) 290
(121, 6) 10
(121, 7) 110
(121, 9) Yes, Continue
(122, 0) TRUE
(122, 2) FALSE
(122, 4) 2
(122, 5) 295
(122, 6) 43
(122, 7) 100
(122, 9) Start Over...
(123, 0) TRUE
(123, 2) TRUE
(123, 3) CHOOSE COLUMN C
(124, 0) TRUE
(124, 2) TRUE
(124, 3) LOOK FOR THE NAME OF THE STOCK IN COLUMN C
(125, 0) FALSE
(125, 2) TRUE
(125, 4) MPM_1.61_HELP!6
(125, 7) 534
(125, 8) 275
(126, 0) FALSE
(126, 2) TRUE
(126, 4) 17
(126, 5) 10
(126, 6) 10
(126, 9) 2
(127, 0) TRUE
(127, 2) FALSE
(127, 3) IF THE PRICE IS A NEW 52 WEEK HIGH THEN PUT IT IN THE CELL FOR THE 52 WEEK HIGH
(127, 4) 5
(127, 5) 60
(127, 6) 20
(127, 9) Select a help topic…
(128, 0) TRUE
(128, 2) FALSE
(128, 3) IF THE PRICE IS A NEW 52 WEEK LOW THEN PUT IT IN THE CELL FOR THE 52 WEEK LOW
(128, 4) 15
(128, 5) 10
(128, 6) 70
(128, 7) 510
(128, 8) 200
(128, 9) HELPTOPICS
(129, 0) TRUE
(129, 2) FALSE
(129, 4) 1
(129, 5) 330
(129, 6) 20
(129, 7) 65
(129, 9) OK
(130, 0) TRUE
(130, 1) PUT THE STOCK SYMBOL IN THE TEMPLATE WHERE THE NEW STOCK SYMBOL GOES
(130, 2) FALSE
(130, 4) 2
(130, 5) 420
(130, 6) 20
(130, 7) 65
(130, 9) Cancel
(131, 0) TRUE
(131, 2) FALSE
(132, 0) TRUE
(132, 2) TRUE
(133, 0) TRUE
(133, 2) TRUE
(133, 3) IF IT IS NOT A NEW PURCHASE THEN YOU ARE ALMOST DONE
(133, 7) 320
(133, 8) 265
(134, 0) TRUE
(134, 2) TRUE
(134, 3) SELECT THE ROW FOR THE TRANSACTION
(134, 4) 5
(134, 5) 110
(134, 6) 15
(134, 9) Welcome to
(135, 0) TRUE
(135, 2) TRUE
(135, 3) INSERT DOWN
(135, 4) 5
(135, 5) 75
(135, 6) 35
(135, 9) “My Portfolio Manager”
(136, 0) TRUE
(136, 2) TRUE
(136, 4) 5
(136, 5) 50
(136, 6) 75
(136, 9) A Microsoft Excel Application
(137, 0) TRUE
(137, 2) TRUE
(137, 4) 5
(137, 5) 113
(137, 6) 110
(137, 9) Written by:
(138, 0) TRUE
(138, 2) TRUE
(138, 3) IF THE PRICE IS A NEW 52 WEEK LOW THEN PUT IT IN THE CELL FOR THE 52 WEEK LOW
(138, 4) 5
(138, 5) 35
(138, 6) 130
(138, 9) Mark Chasteen and Michael Roberts
(138, 10) 1130649267
(139, 0) TRUE
(139, 2) TRUE
(139, 3) PUT THE DATE IN
(139, 4) 5
(139, 5) 45
(139, 6) 160
(139, 9) Version 1.61 - January 31, 1996
(139, 10)
(140, 0) TRUE
(140, 2) TRUE
(140, 3) WRITE THE WORD PURCHASED ONE COLUMN OVER FROM WHERE YOU ARE
(140, 4) 5
(140, 5) 30
(140, 6) 190
(140, 9) NOT REGISTERED - PLEASE REGISTER TODAY
(140, 10)
(141, 0) TRUE
(141, 2) TRUE
(141, 3) WRITE THE NUMBER OF SHARES TWO COLUMNS OVER
(141, 4) 17
(141, 5) 9
(141, 6) 10
(141, 9) 2
(142, 0) TRUE
(142, 2) TRUE
(142, 3) WRITE SHARES@
(142, 4) 1
(142, 5) 123
(142, 6) 225
(142, 7) 64
(142, 9) OK
(143, 0) TRUE
(143, 2) TRUE
(143, 3) WRITE THE PRICE FOUR COLUMNS OVER
(144, 0) TRUE
(144, 1) SELECT THE FIRST ROW OF TABLE
(144, 2) TRUE
(144, 3) WRITE AN EQUAL SIGN 5 COLUMNS OVER
(145, 0) TRUE
(145, 1) INSERT A NEW LINE
(145, 2) TRUE
(145, 4) MPM_1.61_HELP!7
(145, 5) 125
(145, 6) 50
(145, 7) 400
(145, 8) 175
(146, 0) TRUE
(146, 1) THESE SIX LINES TYPES IN THE NEW STOCK INFORMATION
(146, 2) TRUE
(146, 3) FALSE
(146, 4) 5
(146, 5) 15
(146, 6) 15
(146, 9)
(147, 0) TRUE
(147, 2) TRUE
(147, 4) 5
(147, 5) 15
(147, 6) 35
(147, 9)
(148, 0) TRUE
(148, 2) TRUE
(148, 4) 5
(148, 5) 15
(148, 6) 75
(148, 9) Date:
(149, 0) TRUE
(149, 2) TRUE
(149, 4) 8
(149, 5) 100
(149, 6) 72
(149, 7) 120
(149, 10)
(150, 0) TRUE
(150, 2) TRUE
(150, 3) TURN OFF THE ERROR CHECKING
(150, 4) 5
(150, 5) 15
(150, 6) 105
(150, 9) Price:
(151, 0) TRUE
(151, 2) #VALUE!
(151, 3) LOOK UP THE SYMBOL OF THE STOCK AND THEN OPEN IT. IF IT IS AN ITEM IT IS A MISTAKE, BUT KEEP GOING ANYWAY
(151, 4) 8
(151, 5) 100
(151, 6) 102
(151, 7) 120
(152, 0) TRUE
(152, 2) TRUE
(152, 3) LOOK UP THE SYMBOL AND A /DRIP AND OPEN IT. IF THE FILE DOES NOT EXIST THEN IGNORE IT
(152, 4) 5
(152, 5) 15
(152, 6) 135
(152, 9) Fees:
(153, 0) TRUE
(153, 2) TRUE
(153, 3) PUT ERROR CHECKING BACK ON
(153, 4) 8
(153, 5) 100
(153, 6) 132
(153, 7) 120
(154, 0) TRUE
(154, 2) TRUE
(154, 4) 1
(154, 5) 300
(154, 6) 15
(154, 7) 64
(154, 9) OK
(155, 0) TRUE
(155, 2) TRUE
(155, 4) 2
(155, 5) 300
(155, 6) 50
(155, 7) 64
(155, 9) Cancel
(156, 0) TRUE
(156, 1) SELECT THE SECOND ROW OF TABLE
(156, 2) TRUE
(156, 3) SELECT A1 ON THE ACTIVE WORKSHEET
(157, 0) TRUE
(157, 2) TRUE
(157, 3) SELECT C1 ON THE ACTIVE WORKSHEET
(158, 0) TRUE
(158, 2) TRUE
(158, 3) SAVE FILE
(158, 4) MPM_1.61_HELP!8
(158, 5)
(158, 6)
(158, 7) 425
(158, 8) 160
(159, 0) TRUE
(159, 1) PASTE THE FORMATS INTO THE NEW STOCK
(159, 2) TRUE
(159, 4) 17
(159, 5) 9
(159, 6) 9
(159, 9) 2
(160, 0) TRUE
(160, 2) TRUE
(160, 4) 5
(160, 5) 53
(160, 6) 10
(160, 9) Is this information correct:
(161, 0) TRUE
(161, 1) REDEFINE THE NAME LIST TO INCLUDE THE NEW STOCK
(161, 2) TRUE
(161, 4) 5
(161, 5) 16
(161, 6) 65
(161, 9) Transaction date:
(162, 0) TRUE
(162, 1) SELECT THE ENTIRE TABLE
(162, 4) 5
(162, 5) 200
(162, 6) 65
(162, 9)
(163, 0) TRUE
(163, 1) SORT BY NAME
(163, 4) 5
(163, 5) 16
(163, 6) 88
(163, 9) Item:
(164, 0) TRUE
(164, 1) REDEFINE THE NAME TABLE TO INCLUDE THE NEW STOCK
(164, 2) AUTOSTART
(164, 3) IT RUNS EVERY TIME YOU OPEN MPM MACRO SHEET
(164, 4) 5
(164, 5) 200
(164, 6) 88
(164, 9)
(165, 0) TRUE
(165, 2) FALSE
(165, 4) 5
(165, 5) 16
(165, 6) 111
(165, 9) Price per share:
(166, 0) TRUE
(166, 2) TRUE
(166, 4) 5
(166, 5) 200
(166, 6) 111
(166, 9)
(167, 0) TRUE
(167, 2) FALSE
(167, 4) 5
(167, 5) 16
(167, 6) 134
(167, 9) Total fees:
(168, 0) TRUE
(168, 2) #VALUE!
(168, 4) 5
(168, 5) 200
(168, 6) 134
(168, 9)
(169, 0) TRUE
(169, 2) #VALUE!
(169, 4) 1
(169, 5) 290
(169, 6) 10
(169, 7) 110
(169, 9) Yes, Continue
(170, 0) TRUE
(170, 2) TRUE
(170, 4) 2
(170, 5) 295
(170, 6) 43
(170, 7) 100
(170, 9) Start Over...
(171, 0) TRUE
(171, 2) FALSE
(172, 0) TRUE
(172, 2) TRUE
(173, 0) TRUE
(173, 2) TRUE
(173, 4) MPM_1.61_HELP!9
(173, 7) 484
(173, 8) 290
(174, 0) TRUE
(174, 2) FALSE
(174, 4) 17
(174, 5) 9
(174, 6) 9
(174, 9) 2
(175, 0) TRUE
(175, 2) FALSE
(175, 4) 5
(175, 5) 50
(175, 6) 16
(175, 9) This is the information that I have for this item…
(176, 0) TRUE
(176, 1) OPEN A NEW WORKSHEET FOR THE ITEM
(176, 2) FALSE
(176, 4) 5
(176, 5) 40
(176, 6) 55
(176, 9) Name of the item:
(177, 0) TRUE
(177, 2) FALSE
(177, 4) 5
(177, 5) 40
(177, 6) 75
(177, 9) Symbol:
(178, 0) TRUE
(178, 2) TRUE
(178, 4) 5
(178, 5) 40
(178, 6) 95
(178, 9) Shares:
(179, 0) TRUE
(179, 2) TRUE
(179, 3) MAXIMIZE THE FULL AREA OF THE SCREEN
(179, 4) 5
(179, 5) 40
(179, 6) 115
(179, 9) Price:
(180, 0) TRUE
(180, 2) TRUE
(180, 4) 5
(180, 5) 40
(180, 6) 135
(180, 9) Fees:
(181, 0) TRUE
(181, 2) TRUE
(181, 3) SELECT A1 ON THE ACTIVE WORKSHEET
(181, 4) 5
(181, 5) 40
(181, 6) 155
(181, 9) Total proceeds:
(182, 0) TRUE
(182, 2) TRUE
(182, 3) SELECT C1 ON THE ACTIVE WORKSHEET
(182, 4) 5
(182, 5) 40
(182, 6) 175
(182, 9) Time of investment:
(183, 0) TRUE
(183, 2) TRUE
(183, 4) 5
(183, 5) 40
(183, 6) 195
(183, 9) Total return:
(184, 0) TRUE
(184, 2) #N/A!
(184, 3) RUN THE MENU MACRO
(184, 4) 5
(184, 5) 40
(184, 6) 215
(184, 9) Annual return:
(185, 0) TRUE
(185, 2) TRUE
(185, 4) 5
(185, 5) 200
(185, 6) 55
(185, 9)
(186, 0) TRUE
(186, 2) TRUE
(186, 4) 5
(186, 5) 200
(186, 6) 75
(186, 9)
(187, 0) TRUE
(187, 2) TRUE
(187, 4) 5
(187, 5) 200
(187, 6) 95
(187, 9)
(188, 0) TRUE
(188, 4) 5
(188, 5) 200
(188, 6) 115
(188, 9)
(189, 0) TRUE
(189, 4) 5
(189, 5) 200
(189, 6) 135
(189, 9)
(190, 0) TRUE
(190, 2) CLOSE_ITEMS
(190, 3) CLOSES THE ITEMS AND TAKES IT OFF THE SCREEN
(190, 4) 5
(190, 5) 200
(190, 6) 155
(190, 9)
(191, 0) TRUE
(191, 2) FALSE
(191, 3) TURN ECHO OFF
(191, 4) 5
(191, 5) 200
(191, 6) 175
(191, 9)
(192, 0) TRUE
(192, 2) TRUE
(192, 4) 5
(192, 5) 200
(192, 6) 195
(192, 9)
(193, 0) TRUE
(193, 2) TRUE
(193, 3) RESET CALCULATION MODE TO AUTOMATIC
(193, 4) 5
(193, 5) 200
(193, 6) 215
(193, 9)
(194, 0) TRUE
(194, 2) TRUE
(194, 4) 1
(194, 5) 95
(194, 6) 253
(194, 7) 64
(194, 9) OK
(195, 0) TRUE
(195, 2) TRUE
(195, 4) 2
(195, 5) 233
(195, 6) 253
(195, 7) 167
(195, 9) Cancel, Start over…
(196, 0) TRUE
(196, 2) TRUE
(196, 3) FOR AS MANY WINDOWS AS THERE ARE OPEN…
(197, 0) TRUE
(197, 2) TRUE
(197, 3) IF THE DOCUMENT IS A WORKSHEET AND HAS THE ANNUAL RETURN FORMULA IN CELL A1, THEN SAVE AND CLOSE THE DOCUMENT, OTHERWISE, GO TO THE NEXT DOCUMENT.
(198, 0) TRUE
(198, 1) FORMAT THE HEADERS TO GENEVA 10
(198, 2) TRUE
(198, 4) MPM_1.61_HELP!10
(198, 7) 300
(198, 8) 225
(199, 0) TRUE
(199, 1) CENTER THE HEADER
(199, 2) TRUE
(199, 4) 5
(199, 5) 9
(199, 6) 9
(199, 9) Which portfolio should I use…
(200, 0) TRUE
(200, 2) TRUE
(200, 4) 15
(200, 5) 12
(200, 6) 35
(200, 7) 275
(200, 8) 125
(200, 9) PORTFOLIO_LIST
(201, 0) TRUE
(201, 1) ENTER THE TRADING INFORMATION INTO THIS DOCUMENT
(201, 2) TRUE
(201, 4) 1
(201, 5) 70
(201, 6) 185
(201, 7) 64
(201, 9) OK
(202, 0) TRUE
(202, 2) TRUE
(202, 4) 2
(202, 5) 185
(202, 6) 185
(202, 7) 64
(202, 9) Cancel
(203, 0) TRUE
(203, 2) TRUE
(203, 4) 13
(203, 5) 25
(203, 6) 155
(203, 9) Add an item to this portfolio…
(204, 0) TRUE
(204, 2)
(205, 0) TRUE
(206, 0) TRUE
(206, 2) MENU
(206, 7) 440
(206, 8) 280
(207, 0) TRUE
(207, 2) TRUE
(207, 3) FULL MENUS
(207, 4) 17
(207, 5) 10
(207, 6) 10
(207, 9) 2
(208, 0) TRUE
(208, 2) TRUE
(208, 3) IF ERROR DO NOT STOP
(208, 4) 5
(208, 5) 50
(208, 6) 20
(208, 9) Enter your help text below:
(209, 0) TRUE
(209, 2) #VALUE!
(209, 4) 5
(209, 5) 50
(209, 6) 60
(209, 9) Remember, no more than 255 characters.
(210, 0) TRUE
(210, 2) #VALUE!
(210, 4) 5
(210, 5) 50
(210, 6) 80
(210, 9) If you need more than that, click “OK”. This box
(211, 0) TRUE
(211, 2) 1
(211, 4) 5
(211, 5) 74
(211, 6) 95
(211, 9) will reappear as many times as you need.
(212, 0) TRUE
(212, 2) 4
(212, 4) 5
(212, 5) 50
(212, 6) 140
(212, 9) IMPORTANT: If you are finished entering
(213, 0) TRUE
(213, 2) #N/A!
(213, 4) 5
(213, 5) 133
(213, 6) 155
(213, 9) help, click “Done”.
(214, 0) TRUE
(214, 2) 9
(214, 4) 6
(214, 5) 9
(214, 6) 185
(214, 7) 420
(215, 0) TRUE
(215, 2) #N/A!
(215, 4) 1
(215, 5) 125
(215, 6) 230
(215, 7) 64
(215, 9) OK
(216, 0) TRUE
(216, 2) TRUE
(216, 4) 3
(216, 5) 250
(216, 6) 230
(216, 7) 64
(216, 9) Done
(217, 0) TRUE
(218, 0) TRUE
(219, 0) TRUE
(219, 2) MPM_HELP
(219, 4) MPM_1.61_HELP!11
(219, 7) 525
(219, 8) 235
(220, 0) TRUE
(220, 2) TRUE
(220, 4) 17
(220, 5) 10
(220, 6) 10
(220, 9) 2
(221, 0) TRUE
(221, 2) FALSE
(221, 3) JUST DISPLAYS THE DIALOG BOX
(221, 4) 5
(221, 5) 55
(221, 6) 20
(221, 9) Make a selection…
(222, 0) TRUE
(222, 1)
(222, 2) TRUE
(222, 3) IF NOT THE DIALOG BOX THEN HALT
(222, 4) 15
(222, 5) 10
(222, 6) 60
(222, 7) 240
(222, 8) 175
(222, 9)
(223, 0) TRUE
(223, 2) TRUE
(223, 4) 1
(223, 5) 250
(223, 6) 20
(223, 7) 64
(223, 9) OK
(224, 0) TRUE
(224, 2) TRUE
(224, 3) THIS ACTUALLY SHOWS YOU THE HELP INFORMATION
(224, 4) 2
(224, 5) 345
(224, 6) 20
(224, 7) 64
(224, 9) Cancel
(225, 0) TRUE
(225, 2) TRUE
(225, 4) 11
(225, 5) 0
(225, 6) 0
(226, 0) TRUE
(226, 2) TRUE
(226, 4) 12
(226, 5) 255
(226, 6) 60
(226, 9) Delete this item…
(227, 0) TRUE
(227, 1) SELECT THE TRADING INFORMATION ITSELF
(227, 4) 12
(227, 5) 255
(227, 6) 80
(227, 9) New transaction on this item…
(228, 0) TRUE
(228, 1) CENTER IT
(228, 4) 12
(228, 5) 255
(228, 6) 100
(228, 9) Edit/View/Delete a transaction…
(229, 0) TRUE
(229, 2) DELETE_AN_ITEM
(229, 4) 12
(229, 5) 255
(229, 6) 120
(229, 9) Insert a transaction on this item…
(230, 0) TRUE
(230, 2) FALSE
(231, 0) TRUE
(231, 2) FALSE
(232, 0) TRUE
(232, 2) TRUE
(232, 3) MAKES THE HIGHLIGHTED BAR APPEAR AT THE TOP OF THE LIST
(232, 7) 350
(232, 8) 105
(233, 0) TRUE
(233, 1) DEFINE THE TOTAL NUMBER OF SHARES AS THE NAME TOTALSHARES. THIS NAMED CELL WILL BE LINKED TO STOCKS
(233, 2) TRUE
(233, 4) 17
(233, 5) 9
(233, 6) 11
(233, 9) 1
(234, 0) TRUE
(234, 2) TRUE
(234, 3) BLANKS OUT THE DATE, PRICE, AND FEES
(234, 4) 5
(234, 5) 60
(234, 6) 8
(234, 9) Do you want your new
(235, 0) TRUE
(235, 1) DEFINE THE TOTAL NUMBER OF DOLLARS SPENT AS THE NAME TOTALINVESTMENT. THIS NAMED CELL WILL BE LINKED TO STOCKS
(235, 2) 9
(235, 3) DISPLAYS THE DIALOG BOX
(235, 4) 5
(235, 5) 60
(235, 6) 25
(235, 9) portfolio to be included
(236, 0) TRUE
(236, 1) IF THE STOCK HAS AN ITEM THEN SAVE IT WITH THE NAME OF THE SYMBOL AND /DRIP, OTHERWISE SAVE IT AS THE SYMBOL NAME
(236, 2) FALSE
(236, 3) IF THE USER HITS THE CANCEL BUTTON HALT
(236, 4) 5
(236, 5) 60
(236, 6) 42
(236, 9) in your startup group,
(237, 0) TRUE
(237, 1) SELECT THE TOTALSHARES CELL
(237, 2) TRUE
(237, 3) IF THE DATE YOU PUT IN IS LESS THAN NOW THEN GO TO THE NEXT TEST
(237, 4) 5
(237, 5) 60
(237, 6) 59
(237, 9) to be opened every time
(238, 0) TRUE
(238, 2) TRUE
(238, 4) 5
(238, 5) 60
(238, 6) 76
(238, 9) that you use this program?
(239, 0) TRUE
(239, 2) TRUE
(239, 4) 1
(239, 5) 272
(239, 6) 14
(239, 7) 64
(239, 9) Yes
(240, 0) TRUE
(240, 2) TRUE
(240, 4) 2
(240, 5) 272
(240, 6) 51
(240, 7) 64
(240, 9) No
(241, 0) TRUE
(241, 1) PASTE IT IN AS A LINKED CELL
(241, 2) TRUE
(241, 3) IF THE PRICE IS GREATER THAN ZERO GO TO THE NEXT TEST
(242, 0) TRUE
(242, 2) TRUE
(243, 0) TRUE
(243, 1) THIS PUTS IN THE FORMULA THAT LOOKS UP THE PRICE
(243, 2) TRUE
(243, 7) 350
(243, 8) 115
(244, 0) TRUE
(244, 2) TRUE
(244, 4) 17
(244, 5) 10
(244, 6) 10
(244, 9) 1
(245, 0) TRUE
(245, 2) TRUE
(245, 3) MAKE SURE THAT THE FEES ARE GREATER THEN OR EQUAL TO ZERO
(245, 4) 5
(245, 5) 60
(245, 6) 8
(245, 9) The old 52-week high is shown below.
(246, 0) TRUE
(246, 2) FALSE
(246, 4) 5
(246, 5) 60
(246, 6) 25
(246, 9) Click "OK" to accept, or enter the
(247, 0) TRUE
(247, 2) FALSE
(247, 4) 5
(247, 5) 60
(247, 6) 42
(247, 9) new 52-week high, and click "OK"…
(248, 0) TRUE
(248, 2) FALSE
(248, 4) 8
(248, 5) 60
(248, 6) 76
(248, 10)
(249, 0) TRUE
(249, 2) TRUE
(249, 3) PUT INFORMATION INTO A DIALOG BOX
(249, 4) 1
(249, 5) 272
(249, 6) 75
(249, 7) 64
(249, 9) OK
(250, 0) TRUE
(250, 1) THIS WRITES IN THE FORMULA FOR TOTAL GAIN OR LOSS
(250, 2) TRUE
(251, 0) TRUE
(251, 2) TRUE
(252, 0) TRUE
(252, 1) THIS WRITES IN THE FORMULA FOR TOTAL RETURN
(252, 2) TRUE
(252, 7) 350
(252, 8) 115
(253, 0) TRUE
(253, 2) TRUE
(253, 4) 17
(253, 5) 10
(253, 6) 10
(253, 9) 1
(254, 0) TRUE
(254, 2) 11
(254, 3) REPEAT THE ORDER BACK TO THE USER
(254, 4) 5
(254, 5) 60
(254, 6) 8
(254, 9) The old 52-week low is shown below.
(255, 0) TRUE
(255, 2) FALSE
(255, 4) 5
(255, 5) 60
(255, 6) 25
(255, 9) Click "OK" to accept, or enter the
(256, 0) TRUE
(256, 2) TRUE
(256, 3) TURN OFF THE ERROR CHECKING
(256, 4) 5
(256, 5) 60
(256, 6) 42
(256, 9) new 52-week low, and click "OK"…
(257, 0) TRUE
(257, 2) TRUE
(257, 3) LOOK UP THE SYMBOL OF THE STOCK AND THEN OPEN IT. IF IT IS AN ITEM IT IS A MISTAKE, BUT KEEP GOING ANYWAY
(257, 4) 8
(257, 5) 60
(257, 6) 76
(257, 10)
(258, 0) TRUE
(258, 2) #VALUE!
(258, 3) LOOK UP THE SYMBOL AND A /DRIP AND OPEN IT. IF THE FILE DOES NOT EXIST THEN IGNORE IT
(258, 4) 1
(258, 5) 272
(258, 6) 75
(258, 7) 64
(258, 9) OK
(259, 0) TRUE
(259, 1) REACTIVATE THE ITEM DOCUMENT
(259, 2) TRUE
(259, 3) PUT ERROR CHECKING BACK ON
(260, 0) TRUE
(260, 2) FALSE
(260, 3) MAKE SURE THAT AN ITEM WAS OPENED, OTHERWISE STOP
(261, 0) TRUE
(261, 2) TRUE
(261, 4) MPM_1.61_HELP!12
(261, 7) 355
(261, 8) 280
(262, 0) TRUE
(262, 2) TRUE
(262, 4) 17
(262, 5) 9
(262, 6) 15
(262, 9) 1
(263, 0) TRUE
(263, 2) TRUE
(263, 3) TAKES YOU DOWN ONE ROW
(263, 4) 5
(263, 5) 60
(263, 6) 10
(263, 9) The transactions of the item you
(264, 0) TRUE
(264, 1) CLOSE IT WITHOUT A SAVE
(264, 2) TRUE
(264, 3) WRITE THE DATE IN THE ITEM
(264, 4) 5
(264, 5) 60
(264, 6) 25
(264, 9) selected are listed by date.
(265, 0) TRUE
(265, 2) TRUE
(265, 4) 5
(265, 5) 60
(265, 6) 45
(265, 9) Please select the transaction by date.
(266, 0) TRUE
(266, 2) TRUE
(266, 3) PUT THE NUMBER OF SHARES IN THE ITEM
(266, 4) 5
(266, 5) 15
(266, 6) 75
(267, 0) TRUE
(267, 2) TRUE
(267, 3) PUT THE PRICE IN THE CORRECT CELL
(267, 4) 5
(267, 5) 15
(267, 6) 95
(268, 2) TRUE
(268, 3) PUT THE FEES IN THE CORRECT CELL
(268, 4) 15
(268, 5) 15
(268, 6) 125
(268, 7) 171
(268, 8) 142
(269, 2) TRUE
(269, 3) THIS CELL REALLY REFLECTS CASH RECEIVED
(269, 4) 1
(269, 5) 248
(269, 6) 131
(269, 7) 64
(269, 9) OK
(270, 0) ABOUT
(270, 2) TRUE
(270, 3) PASTE THE FORMATS FROM THE ROW ABOVE
(270, 4) 2
(270, 5) 248
(270, 6) 164
(270, 7) 64
(270, 9) Cancel
(271, 0) 9
(271, 2) TRUE
(272, 0) TRUE
(272, 2) TRUE
(273, 2) TRUE
(273, 4) MPM_1.61_HELP!13
(273, 7) 330
(273, 8) 355
(274, 2) TRUE
(274, 4) 17
(274, 5) 11
(274, 6) 4
(274, 9) 1
(275, 0) FIND_PORTFOLIO
(275, 2) TRUE
(275, 4) 5
(275, 5) 66
(275, 6) 15
(275, 9) Here is the information:
(276, 0) TRUE
(276, 2) TRUE
(276, 4) 5
(276, 5) 10
(276, 6) 50
(276, 9)
(277, 0) 3
(277, 2) TRUE
(277, 4) 5
(277, 5) 10
(277, 6) 70
(277, 9)
(278, 0) FALSE
(278, 2) TRUE
(278, 4) 5
(278, 5) 10
(278, 6) 95
(278, 9) Date:
(279, 0) TRUE
(279, 2) TRUE
(279, 3) MAKE SURE THAT THE DATE IS REASONABLE
(279, 4) 6
(279, 5) 125
(279, 6) 92
(279, 7) 100
(279, 10)
(280, 2) FALSE
(280, 4) 5
(280, 5) 10
(280, 6) 125
(280, 9) Transaction:
(281, 2) TRUE
(281, 3) PUTS THE TIME OF INVESTMENT IN THE RIGHT FORMAT
(281, 4) 11
(281, 5) 0
(281, 6) 0
(282, 0) ANNUAL_RETURN_POS
(282, 2) TRUE
(282, 4) 12
(282, 5) 125
(282, 6) 125
(282, 9) Purchase/sale
(283, 0) TRUE
(283, 2) TRUE
(283, 3) FORMULA FOR TOTAL RETURN
(283, 4) 12
(283, 5) 125
(283, 6) 143
(283, 9) Dividend reinvest
(284, 0) TRUE
(284, 2) TRUE
(284, 4) 12
(284, 5) 125
(284, 6) 161
(284, 9) Dividend payout
(285, 0) TRUE
(285, 2) TRUE
(285, 3) ENTERING TOTAL RETURN AS FIRST GUESS OF THE ANNUAL RETURN
(285, 4) 12
(285, 5) 125
(285, 6) 179
(285, 9) Optional cash purchase
(286, 0) TRUE
(286, 2) TRUE
(286, 4) 12
(286, 5) 125
(286, 6) 197
(286, 9) Split or reorganization
(287, 0) TRUE
(287, 2) TRUE
(287, 4) 5
(287, 5) 10
(287, 6) 225
(287, 9) # of shares:
(288, 0) TRUE
(288, 2) TRUE
(288, 4) 8
(288, 5) 127
(288, 6) 222
(288, 7) 100
(289, 0) TRUE
(289, 2) TRUE
(289, 3) THIS WILL CALCULATE THE ANNUAL RETURN BASED ON THE GUESS
(289, 4) 5
(289, 5) 10
(289, 6) 257
(289, 9) Price:
(290, 0) 0.123767147864631
(290, 2) TRUE
(290, 3) IF THE COMPUTED ANSWER BASED ON THE GUESS IS A SATISFACTORY MATCH FOR THE GUESS, THEN CLEAR THE CELL THAT CALCULATES THE ANNUAL RETURN BASED ON THE GUESS. OTHERWISE, PUT THE CALCULATED RETURN INTO THE CELL FOR THE NEW GUESS AND DO THIS COMPARISON AGAIN.
(290, 4) 8
(290, 5) 127
(290, 6) 254
(290, 7) 100
(291, 0) 0.12372355963228
(291, 1) 0
(291, 2) TRUE
(291, 4) 5
(291, 5) 10
(291, 6) 288
(291, 9) Fees:
(292, 0) TRUE
(292, 2) TRUE
(292, 4) 8
(292, 5) 127
(292, 6) 286
(292, 7) 100
(293, 0) FALSE
(293, 2) TRUE
(293, 4) 1
(293, 5) 250
(293, 6) 285
(293, 7) 64
(293, 9) OK
(294, 0) TRUE
(294, 2) TRUE
(294, 4) 2
(294, 5) 250
(294, 6) 315
(294, 7) 64
(294, 9) Cancel
(295, 2) TRUE
(295, 4) 13
(295, 5) 50
(295, 6) 320
(295, 9) Delete this transaction
(296, 2) TRUE
(296, 4)
(296, 5)
(296, 6)
(296, 7)
(296, 8)
(296, 9)
(296, 10)
(297, 0) ANNUAL_RETURN_NEG
(297, 2) TRUE
(298, 0) TRUE
(298, 2) 21
(298, 3) THIS IS YOUR LAST CHANCE. ARE YOU SURE YOU WANT TO DO THIS?
(298, 7) 475
(298, 8) 400
(298, 9) Annual returns table
(299, 0) TRUE
(299, 2) FALSE
(299, 3) IF THE USER HITS CANCEL THEN CLOSE FILE WITHOUT A SAVE THEN START OVER
(299, 4) 17
(299, 5) 11
(299, 6) 4
(299, 9) 2
(300, 0) TRUE
(300, 2) TRUE
(300, 3) DELETE ORIGINAL FILE
(300, 4) 5
(300, 5) 60
(300, 6) 15
(300, 9) Here are the annual returns…
(301, 0) TRUE
(301, 2) TRUE
(301, 4) 5
(301, 5) 35
(301, 6) 50
(301, 9) Item
(302, 0) TRUE
(302, 2) TRUE
(302, 3) SAVE INFORMATION INTO STOCKS SOLD FOLDER
(302, 4) 5
(302, 5) 275
(302, 6) 50
(302, 9) Symbol
(303, 0) TRUE
(303, 2) TRUE
(303, 4) 5
(303, 5) 350
(303, 6) 50
(303, 9) Annual return
(304, 0) TRUE
(304, 2) TRUE
(304, 4) 5
(304, 5) 35
(304, 6) 55
(304, 9) ____
(305, 0) 0.215625032582641
(305, 2) TRUE
(305, 4) 5
(305, 5) 275
(305, 6) 55
(305, 9) ______
(306, 0) 0.21561761384142
(306, 1) 0
(306, 2) TRUE
(306, 4) 5
(306, 5) 350
(306, 6) 55
(306, 9) ____________
(307, 0) TRUE
(307, 2) TRUE
(307, 4) 5
(307, 5) 35
(307, 6) 75
(307, 9)
(308, 0) FALSE
(308, 2) FALSE
(308, 4) 5
(308, 5) 35
(308, 6) 95
(308, 9)
(309, 0) TRUE
(309, 2) FALSE
(309, 4) 5
(309, 5) 35
(309, 6) 115
(309, 9)
(310, 2) FALSE
(310, 4) 5
(310, 5) 35
(310, 6) 135
(310, 9)
(311, 2) TRUE
(311, 4) 5
(311, 5) 35
(311, 6) 155
(311, 9)
(312, 0) MAKE_NEW_PORTFOLIO
(312, 2) TRUE
(312, 4) 5
(312, 5) 35
(312, 6) 175
(312, 9)
(313, 0) FALSE
(313, 2) TRUE
(313, 4) 5
(313, 5) 35
(313, 6) 195
(313, 9)
(314, 0) TRUE
(314, 2) TRUE
(314, 3) YOU ARE NOW AT THE UPPER LEFT OF THE RANGE YOU WANT TO DELETE
(314, 4) 5
(314, 5) 35
(314, 6) 215
(314, 9)
(315, 0) #VALUE!
(315, 2) TRUE
(315, 4) 5
(315, 5) 35
(315, 6) 235
(315, 9)
(316, 0) TRUE
(316, 2) TRUE
(316, 4) 5
(316, 5) 35
(316, 6) 255
(316, 9)
(317, 0) FALSE
(317, 2) TRUE
(317, 4) 5
(317, 5) 35
(317, 6) 275
(317, 9)
(318, 0) TRUE
(318, 2) TRUE
(318, 3) YOU ARE NOW AT THE LOWER RIGHT OF THE RANGE YOU WANT TO DELETE